Letterboxing USA - Yahoo Groups Archive

One more thing so you can hate me again

1 messages in this thread | Started on 2003-08-09

One more thing so you can hate me again

From: maddogbmw (mcjones@layc.org) | Date: 2003-08-09 20:51:04 UTC
WEBSITE SUGGESTION:

SEARCH SCREEN SUGGESTIONS (REALL--EASY--TO-DO-ONES)

I am a programmer and one little thing you could do on the site - is
on the search screen you could alter that 'select statement' that
you fetch/build that 'placer' pull down with to 1) select "DISTINCT"
so you do not get the duplicates, (unless there really is 25 Amy
users then you need to look at having unique user names)

2) Add a where statement there is a SQL JOIN to the letterbox
managers so that only if the placer really owns a letterbox so you
do not get members/placers that do not have a letterbox placed I.E.
like me right now you can find me on the pull down but I do not have
any letterboxes yet sic.- this is simple SQL/ACCESS sql statemnt
stuff -

just a suggestion. Send me the current SQL and the two tables
descriptions and if they are in SQL or ACCESS an I will shoot you
back the correct SQL statement you should deploy.

OK my two cents you can now Hate me again.

MADDOGBMW